How to: Manually recalculate a single cell.
Solution:
Select the cell. Press F2 and then ENTER.
To manually recalculate a single cell:
1) Select the cell to recalculate.
2) Press F2. (The formula appears in the cell.)
3) Press ENTER. (The cell is recalculated.)